/*
 Navicat Premium Data Transfer

 Source Server         : MySQL_zy
 Source Server Type    : MySQL
 Source Server Version : 50735
 Source Host           : 10.20.7.151:3306
 Source Schema         : ztgroup_score

 Target Server Type    : MySQL
 Target Server Version : 50735
 File Encoding         : 65001

 Date: 17/09/2021 12:14:47
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for score
-- ----------------------------
DROP TABLE IF EXISTS `score`;
CREATE TABLE `score` (
  `id` varchar(64) COLLATE utf8_bin NOT NULL COMMENT '主键',
  `emp_id` varchar(64) COLLATE utf8_bin NOT NULL COMMENT '员工编号',
  `name` varchar(64) COLLATE utf8_bin NOT NULL COMMENT '员工姓名',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `creator_id` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `training_score` double(4,2) DEFAULT NULL COMMENT '培训',
  `activity_score` double(4,2) DEFAULT NULL COMMENT '安全活动',
  `suggest_score` double(4,2) DEFAULT NULL COMMENT '创新建议',
  `check_score` double(4,2) DEFAULT NULL COMMENT '隐患排查',
  `accident_score` double(4,2) DEFAULT NULL COMMENT '反三违',
  `score` double(4,2) DEFAULT NULL COMMENT '合计得分情况',
  `remark` varchar(200) COLLATE utf8_bin DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=COMPACT COMMENT='个人积分';

-- ----------------------------
-- Records of score
-- ----------------------------
BEGIN;
INSERT INTO `score` VALUES ('1', '1001', '张三', '2021-09-10 14:08:07', '1003', '2021-09-13 14:08:13', 2.00, 5.00, 3.00, 2.00, -3.00, 9.00, '测试');
INSERT INTO `score` VALUES ('2', '1002', '李四', '2021-08-27 00:00:00', '1003', '2021-08-30 00:00:00', 3.00, 2.00, 1.00, 1.00, -2.00, 5.00, '测试2');
INSERT INTO `score` VALUES ('3', '1003', '王五', '2021-09-01 00:00:00', '1007', '2021-09-22 00:00:00', 2.00, 3.00, 5.00, 0.00, 0.00, 10.00, '测试3');
INSERT INTO `score` VALUES ('4', '1001', '张三', '2021-09-10 00:00:00', '1003', '2021-10-19 00:00:00', 1.00, 2.00, 2.00, 3.00, -1.00, 7.00, '测试5');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
